/******************************************************************************
 * Product: Adempiere ERP & CRM Smart Business Solution                       *
 * Copyright (C) 1999-2007 ComPiere, Inc. All Rights Reserved.                *
 * This program is free software, you can redistribute it and/or modify it    *
 * under the terms version 2 of the GNU General Public License as published   *
 * by the Free Software Foundation. This program is distributed in the hope   *
 * that it will be useful, but WITHOUT ANY WARRANTY, without even the implied *
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.           *
 * See the GNU General Public License for more details.                       *
 * You should have received a copy of the GNU General Public License along    *
 * with this program, if not, write to the Free Software Foundation, Inc.,    *
 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.                     *
 * For the text or an alternative of this public license, you may reach us    *
 * ComPiere, Inc., 2620 Augustine Dr. #245, Santa Clara, CA 95054, USA        *
 * or via info@compiere.org or http://www.compiere.org/license.html           *
 *****************************************************************************/
/** Generated Model - DO NOT CHANGE */
package org.eevolution.model;

import java.math.BigDecimal;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Properties;
import java.util.logging.Level;

import org.compiere.model.*;
import org.compiere.util.CLogger;
import org.compiere.util.DB;
import org.compiere.util.Env;
import org.compiere.util.KeyNamePair;

/** Generated Model for HR_Contract
 *  @author Adempiere (generated) 
 *  @version Release 3.7.0LTS - $Id$ */
public class X_HR_Contract extends PO implements I_HR_Contract, I_Persistent 
{
	/**	Static Logger	*/
	private static CLogger	s_log	= CLogger.getCLogger (X_HR_Contract.class);
	
	/**
	 *
	 */
	private static final long serialVersionUID = 20121003L;

    /** the default Constructor */
    public X_HR_Contract(Properties ctx)
    { 
      super (ctx, null, null);
    } 

    /** Standard Constructor */
    public X_HR_Contract (Properties ctx, int HR_Contract_ID, String trxName)
    {
      super (ctx, HR_Contract_ID, trxName);
      /** if (HR_Contract_ID == 0)
        {
			setC_BPartner_ID (0);
			setHR_Contract_ID (0);
			sethrm_contractType (null);
			sethrm_wageRate_ID (0);
// 1
			setName (null);
			setValidFrom (new Timestamp( System.currentTimeMillis() ));
        } */
    }

    /** Load Constructor */
    public X_HR_Contract (Properties ctx, ResultSet rs, String trxName)
    {
      super (ctx, rs, trxName);
    }

    /** AccessLevel
      * @return 3 - Client - Org 
      */
    protected int get_AccessLevel()
    {
      return accessLevel.intValue();
    }

    /** Load Meta Data */
    protected POInfo initPO (Properties ctx)
    {
      POInfo poi = POInfo.getPOInfo (ctx, Table_ID, get_TrxName());
      return poi;
    }

    public String toString()
    {
      StringBuffer sb = new StringBuffer ("X_HR_Contract[")
        .append(get_ID()).append("]");
      return sb.toString();
    }

	/** Set Amount.
		@param Amount 
		Amount in a defined currency
	  */
	public void setAmount (BigDecimal Amount)
	{
		set_Value (COLUMNNAME_Amount, Amount);
	}

	/** Get Amount.
		@return Amount in a defined currency
	  */
	public BigDecimal getAmount () 
	{
		BigDecimal bd = (BigDecimal)get_Value(COLUMNNAME_Amount);
		if (bd == null)
			 return Env.ZERO;
		return bd;
	}

	public org.compiere.model.I_C_BPartner getC_BPartner() throws RuntimeException
    {
		return (org.compiere.model.I_C_BPartner)MTable.get(getCtx(), org.compiere.model.I_C_BPartner.Table_Name)
			.getPO(getC_BPartner_ID(), get_TrxName());	}

	/** Set Business Partner .
		@param C_BPartner_ID 
		Identifies a Business Partner
	  */
	public void setC_BPartner_ID (int C_BPartner_ID)
	{
		if (C_BPartner_ID < 1) 
			set_Value (COLUMNNAME_C_BPartner_ID, null);
		else 
			set_Value (COLUMNNAME_C_BPartner_ID, Integer.valueOf(C_BPartner_ID));
	}

	/** Get Business Partner .
		@return Identifies a Business Partner
	  */
	public int getC_BPartner_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_C_BPartner_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	public org.compiere.model.I_C_Campaign getC_Campaign() throws RuntimeException
    {
		return (org.compiere.model.I_C_Campaign)MTable.get(getCtx(), org.compiere.model.I_C_Campaign.Table_Name)
			.getPO(getC_Campaign_ID(), get_TrxName());	}

	/** Set Campaign.
		@param C_Campaign_ID 
		Marketing Campaign
	  */
	public void setC_Campaign_ID (int C_Campaign_ID)
	{
		if (C_Campaign_ID < 1) 
			set_Value (COLUMNNAME_C_Campaign_ID, null);
		else 
			set_Value (COLUMNNAME_C_Campaign_ID, Integer.valueOf(C_Campaign_ID));
	}

	/** Get Campaign.
		@return Marketing Campaign
	  */
	public int getC_Campaign_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_C_Campaign_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	/** Set Description.
		@param Description 
		Optional short description of the record
	  */
	public void setDescription (String Description)
	{
		set_Value (COLUMNNAME_Description, Description);
	}

	/** Get Description.
		@return Optional short description of the record
	  */
	public String getDescription () 
	{
		return (String)get_Value(COLUMNNAME_Description);
	}

	/** Set End Date.
		@param EndDate 
		Last effective date (inclusive)
	  */
	public void setEndDate (Timestamp EndDate)
	{
		set_Value (COLUMNNAME_EndDate, EndDate);
	}

	/** Get End Date.
		@return Last effective date (inclusive)
	  */
	public Timestamp getEndDate () 
	{
		return (Timestamp)get_Value(COLUMNNAME_EndDate);
	}

	/** Set Payroll Contract.
		@param HR_Contract_ID Payroll Contract	  */
	public void setHR_Contract_ID (int HR_Contract_ID)
	{
		if (HR_Contract_ID < 1) 
			set_ValueNoCheck (COLUMNNAME_HR_Contract_ID, null);
		else 
			set_ValueNoCheck (COLUMNNAME_HR_Contract_ID, Integer.valueOf(HR_Contract_ID));
	}

	/** Get Payroll Contract.
		@return Payroll Contract	  */
	public int getHR_Contract_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_HR_Contract_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	public org.eevolution.model.I_HR_Department getHR_Department() throws RuntimeException
    {
		return (org.eevolution.model.I_HR_Department)MTable.get(getCtx(), org.eevolution.model.I_HR_Department.Table_Name)
			.getPO(getHR_Department_ID(), get_TrxName());	}

	/** Set Payroll Department.
		@param HR_Department_ID Payroll Department	  */
	public void setHR_Department_ID (int HR_Department_ID)
	{
		if (HR_Department_ID < 1) 
			set_Value (COLUMNNAME_HR_Department_ID, null);
		else 
			set_Value (COLUMNNAME_HR_Department_ID, Integer.valueOf(HR_Department_ID));
	}

	/** Get Payroll Department.
		@return Payroll Department	  */
	public int getHR_Department_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_HR_Department_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	public org.eevolution.model.I_HR_Job getHR_Job() throws RuntimeException
    {
		return (org.eevolution.model.I_HR_Job)MTable.get(getCtx(), org.eevolution.model.I_HR_Job.Table_Name)
			.getPO(getHR_Job_ID(), get_TrxName());	}

	/** Set Payroll Job.
		@param HR_Job_ID Payroll Job	  */
	public void setHR_Job_ID (int HR_Job_ID)
	{
		if (HR_Job_ID < 1) 
			set_Value (COLUMNNAME_HR_Job_ID, null);
		else 
			set_Value (COLUMNNAME_HR_Job_ID, Integer.valueOf(HR_Job_ID));
	}

	/** Get Payroll Job.
		@return Payroll Job	  */
	public int getHR_Job_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_HR_Job_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	/** Set hrm_confidentialityAgreement.
		@param hrm_confidentialityAgreement hrm_confidentialityAgreement	  */
	public void sethrm_confidentialityAgreement (boolean hrm_confidentialityAgreement)
	{
		set_Value (COLUMNNAME_hrm_confidentialityAgreement, Boolean.valueOf(hrm_confidentialityAgreement));
	}

	/** Get hrm_confidentialityAgreement.
		@return hrm_confidentialityAgreement	  */
	public boolean ishrm_confidentialityAgreement () 
	{
		Object oo = get_Value(COLUMNNAME_hrm_confidentialityAgreement);
		if (oo != null) 
		{
			 if (oo instanceof Boolean) 
				 return ((Boolean)oo).booleanValue(); 
			return "Y".equals(oo);
		}
		return false;
	}

	/** hrm_contractType AD_Reference_ID=1000045 */
	public static final int HRM_CONTRACTTYPE_AD_Reference_ID=1000045;
	/** confidality agreement = 5 */
	public static final String HRM_CONTRACTTYPE_ConfidalityAgreement = "5";
	/** additional agreement = 4 */
	public static final String HRM_CONTRACTTYPE_AdditionalAgreement = "4";
	/** compensation for education = 3 */
	public static final String HRM_CONTRACTTYPE_CompensationForEducation = "3";
	/** liability for breakage = 2 */
	public static final String HRM_CONTRACTTYPE_LiabilityForBreakage = "2";
	/** labor  = 1 */
	public static final String HRM_CONTRACTTYPE_Labor = "1";
	/** Set hrm_contractType.
		@param hrm_contractType hrm_contractType	  */
	public void sethrm_contractType (String hrm_contractType)
	{

		set_Value (COLUMNNAME_hrm_contractType, hrm_contractType);
	}

	/** Get hrm_contractType.
		@return hrm_contractType	  */
	public String gethrm_contractType () 
	{
		return (String)get_Value(COLUMNNAME_hrm_contractType);
	}

	/** Set hrm_coursename.
		@param hrm_coursename hrm_coursename	  */
	public void sethrm_coursename (String hrm_coursename)
	{
		set_Value (COLUMNNAME_hrm_coursename, hrm_coursename);
	}

	/** Get hrm_coursename.
		@return hrm_coursename	  */
	public String gethrm_coursename () 
	{
		return (String)get_Value(COLUMNNAME_hrm_coursename);
	}

	/** Set hrm_liabilityForBreakageSigne.
		@param hrm_liabilityForBreakageSigne hrm_liabilityForBreakageSigne	  */
	public void sethrm_liabilityForBreakageSigne (boolean hrm_liabilityForBreakageSigne)
	{
		set_Value (COLUMNNAME_hrm_liabilityForBreakageSigne, Boolean.valueOf(hrm_liabilityForBreakageSigne));
	}

	/** Get hrm_liabilityForBreakageSigne.
		@return hrm_liabilityForBreakageSigne	  */
	public boolean ishrm_liabilityForBreakageSigne () 
	{
		Object oo = get_Value(COLUMNNAME_hrm_liabilityForBreakageSigne);
		if (oo != null) 
		{
			 if (oo instanceof Boolean) 
				 return ((Boolean)oo).booleanValue(); 
			return "Y".equals(oo);
		}
		return false;
	}

	public I_hrm_order gethrm_order() throws RuntimeException
    {
		return (I_hrm_order)MTable.get(getCtx(), I_hrm_order.Table_Name)
			.getPO(gethrm_order_ID(), get_TrxName());	}

	/** Set hrm_order.
		@param hrm_order_ID hrm_order	  */
	public void sethrm_order_ID (int hrm_order_ID)
	{
		if (hrm_order_ID < 1) 
			set_Value (COLUMNNAME_hrm_order_ID, null);
		else 
			set_Value (COLUMNNAME_hrm_order_ID, Integer.valueOf(hrm_order_ID));
	}

	/** Get hrm_order.
		@return hrm_order	  */
	public int gethrm_order_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_hrm_order_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	/** Set hrm_orgName.
		@param hrm_orgName hrm_orgName	  */
	public void sethrm_orgName (String hrm_orgName)
	{
		set_Value (COLUMNNAME_hrm_orgName, hrm_orgName);
	}

	/** Get hrm_orgName.
		@return hrm_orgName	  */
	public String gethrm_orgName () 
	{
		return (String)get_Value(COLUMNNAME_hrm_orgName);
	}

	public I_hrm_trialperiod gethrm_trialperiod() throws RuntimeException
    {
		return (I_hrm_trialperiod)MTable.get(getCtx(), I_hrm_trialperiod.Table_Name)
			.getPO(gethrm_trialperiod_ID(), get_TrxName());	}

	/** Set hrm_trialperiod.
		@param hrm_trialperiod_ID hrm_trialperiod	  */
	public void sethrm_trialperiod_ID (int hrm_trialperiod_ID)
	{
		if (hrm_trialperiod_ID < 1) 
			set_Value (COLUMNNAME_hrm_trialperiod_ID, null);
		else 
			set_Value (COLUMNNAME_hrm_trialperiod_ID, Integer.valueOf(hrm_trialperiod_ID));
	}

	/** Get hrm_trialperiod.
		@return hrm_trialperiod	  */
	public int gethrm_trialperiod_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_hrm_trialperiod_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	public I_hrm_wageRate gethrm_wageRate() throws RuntimeException
    {
		return (I_hrm_wageRate)MTable.get(getCtx(), I_hrm_wageRate.Table_Name)
			.getPO(gethrm_wageRate_ID(), get_TrxName());	}

	/** Set wage-rate.
		@param hrm_wageRate_ID wage-rate	  */
	public void sethrm_wageRate_ID (int hrm_wageRate_ID)
	{
		if (hrm_wageRate_ID < 1) 
			set_Value (COLUMNNAME_hrm_wageRate_ID, null);
		else 
			set_Value (COLUMNNAME_hrm_wageRate_ID, Integer.valueOf(hrm_wageRate_ID));
	}

	/** Get wage-rate.
		@return wage-rate	  */
	public int gethrm_wageRate_ID () 
	{
		Integer ii = (Integer)get_Value(COLUMNNAME_hrm_wageRate_ID);
		if (ii == null)
			 return 0;
		return ii.intValue();
	}

	/** Set Name.
		@param Name 
		Alphanumeric identifier of the entity
	  */
	public void setName (String Name)
	{
		set_Value (COLUMNNAME_Name, Name);
	}

	/** Get Name.
		@return Alphanumeric identifier of the entity
	  */
	public String getName () 
	{
		return (String)get_Value(COLUMNNAME_Name);
	}

    /** Get Record ID/ColumnName
        @return ID/ColumnName pair
      */
    public KeyNamePair getKeyNamePair() 
    {
        return new KeyNamePair(get_ID(), getName());
    }

	/** Set Start Date.
		@param StartDate 
		First effective day (inclusive)
	  */
	public void setStartDate (Timestamp StartDate)
	{
		set_Value (COLUMNNAME_StartDate, StartDate);
	}

	/** Get Start Date.
		@return First effective day (inclusive)
	  */
	public Timestamp getStartDate () 
	{
		return (Timestamp)get_Value(COLUMNNAME_StartDate);
	}

	/** Set Valid from.
		@param ValidFrom 
		Valid from including this date (first day)
	  */
	public void setValidFrom (Timestamp ValidFrom)
	{
		set_Value (COLUMNNAME_ValidFrom, ValidFrom);
	}

	/** Get Valid from.
		@return Valid from including this date (first day)
	  */
	public Timestamp getValidFrom () 
	{
		return (Timestamp)get_Value(COLUMNNAME_ValidFrom);
	}

	/** Set Valid to.
		@param ValidTo 
		Valid to including this date (last day)
	  */
	public void setValidTo (Timestamp ValidTo)
	{
		set_Value (COLUMNNAME_ValidTo, ValidTo);
	}

	/** Get Valid to.
		@return Valid to including this date (last day)
	  */
	public Timestamp getValidTo () 
	{
		return (Timestamp)get_Value(COLUMNNAME_ValidTo);
	}

	/** Set Search Key.
		@param Value 
		Search key for the record in the format required - must be unique
	  */
	public void setValue (String Value)
	{
		set_Value (COLUMNNAME_Value, Value);
	}

	/** Get Search Key.
		@return Search key for the record in the format required - must be unique
	  */
	public String getValue () 
	{
		return (String)get_Value(COLUMNNAME_Value);
	}
	
	 /** Load Model for BPartner */
    public static X_HR_Contract getHR_Contract (int C_BPartner_ID, boolean isActive){
    	
    	if(C_BPartner_ID == 0)    		
    		return null;
    	
    	String active = "AND ISACTIVE='Y'";
    	if((Boolean) isActive == null)
    		active = "";
    	else if(!isActive)
    		active = "AND ISACTIVE='N'";
    	    	
    	PreparedStatement pstmt = null;
		ResultSet rs = null;
		X_HR_Contract result = null;
		
		// Employee data from the card
		String sql_ = " SELECT * FROM HR_CONTRACT \n " +
						" WHERE AD_CLIENT_ID=" + Env.getAD_Client_ID(Env.getCtx()) + " \n " +
						  " AND C_BPARTNER_ID=" + C_BPartner_ID + " \n " + active;
		try
		{
			pstmt = DB.prepareStatement(sql_,null);
			rs = pstmt.executeQuery();
			if(rs.next())
				result = new X_HR_Contract(Env.getCtx(), rs, null);			
		}
		catch (SQLException e)
		{
			s_log.log(Level.SEVERE, "product", e);
		}
		finally
		{
			DB.close(rs, pstmt);
			rs = null; pstmt = null;
		}
		
		return result;	
    }
}